UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U0aIyWrozuFNIWCJb8EAbzJ9JLrYXTWyaIcEehjkFh4='
WHERE
key_id = '0c739a8937dd4df9792a1d8273780db8273a5d66f8556e16841ed5db0a52b395'
AND (
token = 'U0aIyWrozuFNIWCJb8EAbzJ9JLrYXTWyaIcEehjkFh4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)