UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h9NXLFGpsl7wCGRTA2wjsJOwBjE2nWtT296q9HdjGBE='
WHERE
key_id = '156fbb16efd3e73e05f22b94b8df40e4adefd7988f3c89b5c16e01e5a6f094f3'
AND (
token = 'h9NXLFGpsl7wCGRTA2wjsJOwBjE2nWtT296q9HdjGBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)