UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pA6xrSSK+WUFIQFx8qsm0LSxrAOHn1ITA8PSboRDnpM='
WHERE
key_id = 'f984f89a71c476791c5b769dabcf5e7770e91fcbd765473ea12b64f12f4e3d17'
AND (
token = 'pA6xrSSK+WUFIQFx8qsm0LSxrAOHn1ITA8PSboRDnpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)