UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QPIFuYxv2FkldN0kAf376fCU9rBENk98AfLZ3WFj/AM='
WHERE
key_id = 'bcf7b115fe7b6d57b5619c0be99e03ba9c0d8049fb41aea1900fd873253d5696'
AND (
token = 'QPIFuYxv2FkldN0kAf376fCU9rBENk98AfLZ3WFj/AM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)