UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uVwpO2UQe/7+crl08lcUlRD8Fx39zTli7j+aCH6RmOg='
WHERE
key_id = 'af9d3d760632f58cbbf4bf39b6e6f3e92e7fa144c076a7a28c525812d5e83bfa'
AND (
token = 'uVwpO2UQe/7+crl08lcUlRD8Fx39zTli7j+aCH6RmOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)