UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J5vC7jJavOi6cQ6kkoic9GYTK4QvcgzQRkKtCAD9kws='
WHERE
key_id = 'a5073f8b43cd8964ff89e7dee4186a8b865c76716d78c273eb36b36014b8310b'
AND (
token = 'J5vC7jJavOi6cQ6kkoic9GYTK4QvcgzQRkKtCAD9kws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)