UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yj1typ5ZOmkExitaRi7CRdlfAzacT8LuN6xYJpgT/qk='
WHERE
key_id = 'c9d93a4ff2807b712246b8d460fb0b65565f0c559eca9a5c5a82ed887101e37e'
AND (
token = 'Yj1typ5ZOmkExitaRi7CRdlfAzacT8LuN6xYJpgT/qk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)