UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EDKa19I9ZpqEt5bJkX+wC7U9DpVfSDXG03o2V59NfrM='
WHERE
key_id = '8c495d377e2f56ddfe28505b6fe96dcff43d0d782e7ecda44ec47eb8b632ff91'
AND (
token = 'EDKa19I9ZpqEt5bJkX+wC7U9DpVfSDXG03o2V59NfrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)