UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qig3FA28+CvaV+05KXB1mJ64I5eq14JcCT9EyCd/eRw='
WHERE
key_id = '8bf8d59e7f76b9b2089d87f7aac44ff670558dc3064bf3ebc9dc9b5496fb3e14'
AND (
token = 'qig3FA28+CvaV+05KXB1mJ64I5eq14JcCT9EyCd/eRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)