UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cCu9yA9ZRNUj2FBOL/iR4o24e9jtjk8XjveNlRWDIzA='
WHERE
key_id = 'e9404924e18f18d71c006372558f1651d43bcb6993994e586f5a6b662c7e55f6'
AND (
token = 'cCu9yA9ZRNUj2FBOL/iR4o24e9jtjk8XjveNlRWDIzA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)