UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2gLOeg/sokTL0vLdZrh/wQ938e0MQ+5DE5YWDs+2yWQ='
WHERE
key_id = '5a31ca24bb72e29264ad265df2768bb4ce7706051675573c8a3bc03d4ad7d8e8'
AND (
token = '2gLOeg/sokTL0vLdZrh/wQ938e0MQ+5DE5YWDs+2yWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)