UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nNb6PgUmtuop9p8erL8MwBKhSz7kMOk7cOyQQ3q9Plw='
WHERE
key_id = '2b44cadfab102fcdf7215941aff20dc456652bf62caaf002cc8908f1f16ac2a9'
AND (
token = 'nNb6PgUmtuop9p8erL8MwBKhSz7kMOk7cOyQQ3q9Plw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)