UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ei5ot8DBi+ai+X7twAfOL9dDQAsA3rZ2xUiN4ok5uS4='
WHERE
key_id = 'c1edbcc0d1b5018f989f73f11d0dede407273e85f3882ec2391444b26dee9172'
AND (
token = 'Ei5ot8DBi+ai+X7twAfOL9dDQAsA3rZ2xUiN4ok5uS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)