UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R1eJHfufiEGk9ranbGSZJjL6HRcyG9cQ1wNRTisd3M0='
WHERE
key_id = 'f780d14639e742166e7a647b1ff9d5b445545c11ba21b6011fdeb28c7d3f0511'
AND (
token = 'R1eJHfufiEGk9ranbGSZJjL6HRcyG9cQ1wNRTisd3M0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)