UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R6EPPXG4+gAdQCk7sABzrwZRPPe2MJp8qLiFSrcgUaw='
WHERE
key_id = '048c8777f5f1ad043ea09f5a00707847ea9095db95b454f20ea7c823cd35a66f'
AND (
token = 'R6EPPXG4+gAdQCk7sABzrwZRPPe2MJp8qLiFSrcgUaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)