UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvI6ZQcli3fq76+2GEJw6jI061BYG3830+B1Ttpr354='
WHERE
key_id = '08e157c87ed24f71e1f71baa38629e19d13eab7ab6993de4734e03fd097d871e'
AND (
token = 'pvI6ZQcli3fq76+2GEJw6jI061BYG3830+B1Ttpr354='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)