UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S6n10wEg1E5YXa59g/ASmnB70OMdtTddPjRGelO517U='
WHERE
key_id = '3bc24db47e9d6c54fbf80942653ae2fdbcfeb3b566b77b2be56e4a2880662ba4'
AND (
token = 'S6n10wEg1E5YXa59g/ASmnB70OMdtTddPjRGelO517U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)