UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '55R/VrN2GSXppTtE54FLSD6BajPis8f6T5Anf4mqS14='
WHERE
key_id = 'b9fdfed77a4fe1455e6ceccc1df10e8556a1d7daa050d0b05d0d889379b29753'
AND (
token = '55R/VrN2GSXppTtE54FLSD6BajPis8f6T5Anf4mqS14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)