UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3c7xDwOkdwn3XIc4tA6UYtZSlW3x6jLVGfF+W6qws4g='
WHERE
key_id = 'b4fe3e2877a1ddf7a1099a57c61480fb1a2139957c73b2f438de464b6fb276ee'
AND (
token = '3c7xDwOkdwn3XIc4tA6UYtZSlW3x6jLVGfF+W6qws4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)