UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'trSf4/9iUQa6kH3ZOOV37xpPCgpzTgMSEw6X/atx2Pg='
WHERE
key_id = '03313c2a83828197a83c002a7ef3eca50dfa3dc406f190809974c6f987898dc3'
AND (
token = 'trSf4/9iUQa6kH3ZOOV37xpPCgpzTgMSEw6X/atx2Pg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)