UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fYcOzEY8KkrgmIbV691nL9hO/ds9wblYcAl0xdeauI='
WHERE
key_id = '9165eac715f635ae4bc35792dd79196abffc14f124a7bbf6c62e46ad88635efe'
AND (
token = '0fYcOzEY8KkrgmIbV691nL9hO/ds9wblYcAl0xdeauI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)