UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5NtC+h1p3Pq7wzt6lifcZIbeINFVD28kCIlgts7gOLc='
WHERE
key_id = 'b9b29c090e5f70ac9197b8c76bac05f5e2b0d58f3504a985d23897194435edbc'
AND (
token = '5NtC+h1p3Pq7wzt6lifcZIbeINFVD28kCIlgts7gOLc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)