UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8rCkWmRpqR9p6erVYnoYXjFuI4OTKU2TlmQ9hr7po5U='
WHERE
key_id = 'ca341c2ad0548e110918567d9dde266d41069d80ae2d89f363fbea3a48100b20'
AND (
token = '8rCkWmRpqR9p6erVYnoYXjFuI4OTKU2TlmQ9hr7po5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)