UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8J0/7oM5rz0o/LsI7JmWwj2VI0VXj0lZCCX9Plwa1Ts='
WHERE
key_id = 'd7a6d0a0b31548590c1b7316dfd79fb72e665aff2eef9579c86ea5f143f3972e'
AND (
token = '8J0/7oM5rz0o/LsI7JmWwj2VI0VXj0lZCCX9Plwa1Ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)