UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NBQz1N+6HvVgUbRVrl7QvjsTNB+oYVnucyOObsPo2dY='
WHERE
key_id = 'a8929c606bf188a2b60c212e7e90e8e0cd1dd617b6932ecdd825584a3a31c3cd'
AND (
token = 'NBQz1N+6HvVgUbRVrl7QvjsTNB+oYVnucyOObsPo2dY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)