UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j9ctiDbDMJBGswYmHCe0GH5xVbF1w+z4TSuUWX2w3yk='
WHERE
key_id = 'd87c5b12c9ef5f2c02f4a1f3ee72d1e43d6c699652cfc6dfbae747f915ff7346'
AND (
token = 'j9ctiDbDMJBGswYmHCe0GH5xVbF1w+z4TSuUWX2w3yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)