UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YOXbt178D0ezvksbaN1Plc+kjmnsUS59gSxdU9kes4='
WHERE
key_id = 'b0ac90c15a0b0031492b6bc9152785c1022c1c0e76b075f0f4b3f6454c34dc87'
AND (
token = '8YOXbt178D0ezvksbaN1Plc+kjmnsUS59gSxdU9kes4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)