UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dz8rocPKdRyCV+QB7ASI3pEElSHA3XEQQBDNdmkySfA='
WHERE
key_id = 'ef091971e7d3b04e6baca028f81c3740baf794dea841b452250ec626dd5c7165'
AND (
token = 'dz8rocPKdRyCV+QB7ASI3pEElSHA3XEQQBDNdmkySfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)