UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PuJdQr0cS/+g+TOQX2dwfmVmaJKXBHRM3eiJxoXhirM='
WHERE
key_id = 'dbe607ad96263fa4a8e09cc6380264a80852f364bd1ff5d618e2b2aa3a4b122a'
AND (
token = 'PuJdQr0cS/+g+TOQX2dwfmVmaJKXBHRM3eiJxoXhirM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)