UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JXdxaJWnxM7g0wvpAofxwFdrVYd6XtiX7iLPLIJncLc='
WHERE
key_id = '4c0d883548faddf76026a470f18d959d85760c2068c945855c5d30d76bf5b9c1'
AND (
token = 'JXdxaJWnxM7g0wvpAofxwFdrVYd6XtiX7iLPLIJncLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)