UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5UpeYY1xd8Av+zBp/aSHdLSY2+46WUJ1yuoavBlxdUc='
WHERE
key_id = 'dc8b263ffedb17f2132879610bafc7182017f7cb5fd8a95742125e73431d9f8a'
AND (
token = '5UpeYY1xd8Av+zBp/aSHdLSY2+46WUJ1yuoavBlxdUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)